/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 17655
 * Date: 2025-03-13
 * Time: 14:11
 */
public class test13 {
    /**
     * LeetCode 570
     */

    /**
     * 解析：找有五名下属的经理，所以把这一张表拆分成两张表使用，这两张表一张的id要等于另外一张的经理id
     */
    /*
    select name from
    (select Manager.name as name,count(report.id) as cnt from Employee as manager join Employee as report
    on manager.id = report.managerId group by manager.id
    )as reportcount where cnt>=5;
     */

    /*
    select manager.name as name from Employee as manager join Employee as report
    on manager.id = report.managerId
    group by manager.id
    having count(report.id)>=5;
     */
}
